﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="issuesoverview.aspx.cs" Inherits="Com.Rivyer.Web.issue.issuesoverview" %>

<%@ Register Assembly="DevExpress.Web.ASPxGridView.v11.2.Export, Version=11.2.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxGridView.Export" TagPrefix="dx" %>

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title>反馈进度</title>
    <link href="../css/style.css" rel="stylesheet" type="text/css" />
    <link href="../css/rivcontent.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <form id="form1" runat="server">
    <%if (DesignMode)
      { %>
    <script type="text/javascript" src="../js/ASPxScriptIntelliSense.js"></script>
    <%} %>
    <script type="text/javascript">
        
    </script>
    <div>
        <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
            <tr>
                <td height="30">
                    <table width="100%" border="0" cellspacing="0" cellpadding="0">
                        <tr>
                            <td height="24" bgcolor="#353c44">
                                <table width="100%" border="0" cellspacing="0" cellpadding="0">
                                    <tr>
                                        <td>
                                            <table width="100%" border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td width="6%" height="19" valign="bottom">
                                                        <div align="center">
                                                            <img src="../images/tb.gif" width="14" height="14" /></div>
                                                    </td>
                                                    <td width="94%" valign="bottom">
                                                        <span class="STYLE1">反馈进度</span>
                                                    </td>
                                                </tr>
                                            </table>
                                        </td>
                                    </tr>
                                </table>
                            </td>
                        </tr>
                    </table>
                </td>
            </tr>
            <tr>
                <td align="center" style="font-size: 12px; width=100%">
                    <div id="rivcontent">
                        <div class="title">反馈信息进度一览</div>
                        <dx:ASPxGridView ID="issuesstatusgrid" runat="server" 
                            AutoGenerateColumns="False" DataSourceID="SqlDataSource1" 
                            KeyFieldName="id" Font-Size="12px" Width="800px" 
                            onrowupdated="issuesstatusgrid_RowUpdated" 
                            onrowupdating="issuesstatusgrid_RowUpdating">
                            <Columns>
                                <dx:GridViewCommandColumn VisibleIndex="0">
                                    <EditButton Visible="True">
                                    </EditButton>
                                    <ClearFilterButton Visible="True">
                                    </ClearFilterButton>
                                </dx:GridViewCommandColumn>
                                <dx:GridViewDataTextColumn FieldName="id" ReadOnly="True" Visible="False" 
                                    VisibleIndex="1">
                                    <EditFormSettings Visible="False" />
                                </dx:GridViewDataTextColumn>
                                <dx:GridViewDataTextColumn Caption="用户名" FieldName="username" VisibleIndex="2">
                                    <EditFormSettings Visible="False" />
                                </dx:GridViewDataTextColumn>
                                <dx:GridViewDataDateColumn Caption="提交日期" FieldName="createdate" 
                                    VisibleIndex="3">
                                    <PropertiesDateEdit DisplayFormatString="yyyy/MM/dd">
                                    </PropertiesDateEdit>
                                    <EditFormSettings Visible="False" />
                                </dx:GridViewDataDateColumn>
                                <dx:GridViewDataTextColumn Caption="问题类型" FieldName="issuetype" 
                                    VisibleIndex="4">
                                    <EditFormSettings Visible="False" />
                                </dx:GridViewDataTextColumn>
                                <dx:GridViewDataMemoColumn Caption="问题描述" FieldName="issuedescription" 
                                    VisibleIndex="5">
                                    <EditFormSettings Visible="False" />
                                </dx:GridViewDataMemoColumn>
                                <dx:GridViewDataMemoColumn Caption="管理员回复" FieldName="adminaply" 
                                    VisibleIndex="6">
                                </dx:GridViewDataMemoColumn>
                                <dx:GridViewDataTextColumn Caption="状态" FieldName="status" 
                                    VisibleIndex="7">
                                </dx:GridViewDataTextColumn>
                                <dx:GridViewDataDateColumn Caption="回复日期" FieldName="modifydate" 
                                    VisibleIndex="8">
                                    <PropertiesDateEdit DisplayFormatString="MM/dd hh:mm:ss">
                                    </PropertiesDateEdit>
                                    <EditFormSettings Visible="False" />
                                </dx:GridViewDataDateColumn>
                            </Columns>
                            <SettingsPager PageSize="13">
                            </SettingsPager>
                            <Settings ShowFilterRow="True" ShowFilterRowMenu="True" ShowGroupPanel="True" />
                            <Styles>
                                <Header HorizontalAlign="Center">
                                </Header>
                                <Cell HorizontalAlign="Center">
                                </Cell>
                            </Styles>
                        </dx:ASPxGridView>
                        <div class="space">
                            <dx:ASPxButton ID="ASPxButton1" runat="server" Text="导出数据" 
                                onclick="ASPxButton1_Click">
                            </dx:ASPxButton>
                        </div>
                        
                    </div>
                </td>
            </tr>
        </table>
    </div>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                            ConnectionString="<%$ ConnectionStrings:ITConnectionString %>" 
                            DeleteCommand="DELETE FROM [tb_userissues] WHERE [id] = @id" 
                            InsertCommand="INSERT INTO [tb_userissues] ([username], [createdate], [issuetype], [issuedescription], [adminaply], [status], [modifydate]) VALUES (@username, @createdate, @issuetype, @issuedescription, @adminaply, @status, @modifydate)" 
                            ProviderName="System.Data.SqlClient" 
                            SelectCommand="SELECT * FROM [tb_userissues] ORDER BY [createdate] DESC" 
                            UpdateCommand="UPDATE [tb_userissues] SET [username] = @username, [createdate] = @createdate, [issuetype] = @issuetype, [issuedescription] = @issuedescription, [adminaply] = @adminaply, [status] = @status, [modifydate] = @modifydate WHERE [id] = @id">
                            <DeleteParameters>
                                <asp:Parameter Name="id" Type="Int32" />
                            </DeleteParameters>
                            <InsertParameters>
                                <asp:Parameter Name="username" Type="String" />
                                <asp:Parameter DbType="Date" Name="createdate" />
                                <asp:Parameter Name="issuetype" Type="String" />
                                <asp:Parameter Name="issuedescription" Type="String" />
                                <asp:Parameter Name="adminaply" Type="String" />
                                <asp:Parameter Name="status" Type="String" />
                                <asp:Parameter Name="modifydate" Type="DateTime" />
                            </InsertParameters>
                            <UpdateParameters>
                                <asp:Parameter Name="username" Type="String" />
                                <asp:Parameter DbType="Date" Name="createdate" />
                                <asp:Parameter Name="issuetype" Type="String" />
                                <asp:Parameter Name="issuedescription" Type="String" />
                                <asp:Parameter Name="adminaply" Type="String" />
                                <asp:Parameter Name="status" Type="String" />
                                <asp:Parameter Name="modifydate" Type="DateTime" />
                                <asp:Parameter Name="id" Type="Int32" />
                            </UpdateParameters>
                        </asp:SqlDataSource>
    <dx:ASPxGridViewExporter ID="ASPxGridViewExporter1" runat="server" GridViewID="issuesstatusgrid">
    </dx:ASPxGridViewExporter>
    </form>
</body>
</html>
